﻿
Public Class CTLoadInstrument

     private  _0_instrument                   as string
     private  _1_tipo                         as string
     private  _2_emision                      as string
     private  _3_acronimo                     as string
     private  _4_longname1                    as string
     private  _5_tipodeinstrumentodecalog     as string
     private  _6_tv                           as string
     private  _7_rendimiento                  as string
     private  _8_emisora                      as string
     private  _9_tipoinstrumento              as string
     private  _10_fijofrevisablerdescuentod   as string
     private  _11_cuponesporvencer            as string
     private  _12_cuponevencidos              as string
     private  _13_periododecupo_1             as string
     private  _14_periododecupon_2            as string
     private  _15_sobretasademercado          as string
     private  _16_sobretasatotal              as string
     private  _17_tasacupon_1                 as string
     private  _18_tasacupon_2                 as string
     private  _19_fechadecolocacion           as string
     private  _20_fechadevencimiento          as string
     private  _21_diasporvencer               as string
     private  _22_preciosuciomd_1             as string
     private  _23_preciosuciomd_2             as string
     private  _24_preciolimpiomd              as string
     private  _25_sucio24hrs                  as string
     private  _26_duracionajustada            as string
     private  _27_convexidad                  as string
     private  _28_valornominalactualizado     as string
     private  _29_redemptionprice             as string
     private  _30_valoresinscritos            as string
     private  _31_montoencirculacion          as string
     private  _32_isin_1                      as string
     private  _33_isin_2                      as string
     private  _34_isin_3                      as string
     private  _35_curvadedescuento            as string
     private  _36_codigoindice                as string
     private  _37_tipointeres                 as string
     private  _38_iniciodecupon               as string
     private  _39_findecupon                  as string
     private  _40_fitch                       as string
     private  _41_syp                         as string
     private  _42_moodys                      as string
     private  _43_sobretasaendecalog          as string
     private  _44_sobretasadecolocacion       as string
     private  _45_isr                         as string
     private  _46_guartyp                     as string
     private  _47_serie                       as string
     private  _48_tipoderevision              as string
     private  _49_tipoderevisioncs            as string
     private  _50_numofdaystype               as string
     private  _51_category                    as string
     private  _52_numdays                     as string
     private  _53_diasporvencer               as string
     private  _54_fechaemision                as string
     private  _55_fechavencimiento            as string
     private  _56_finicicupon                 as string
     private  _57_ffinalcupon                 as string
     private  _58_preciosuciomd               as string
     private  _59_preciolimpiomd              as string
     private  _60_valornominal                as string
     private  _61_titulosdelemision           as string
     private  _62_montodelaemision            as string
     private  _63_tasacupon                   as string
     private  _64_strike1                     as string
     private  _65_strike2                     as string
     private  _66_tasamaxima_tim              as string
     private  _67_tasaminimagarantizada_tmg   as string
     private  _68_subyacente                  as string
     private  _69_estructura                  as string
     private  _70_concatenacion_nombre        as string
     private  _71_notaendecalog               as string
     private  _72_diasporvenceremision        as string
     private  _73_diasporvenceremision        as string
     private  _74_periodocupon                as string
     private  _75_cuponesporvencer            as string
     private  _76_cuponesvencidos             as string
     private  _77_periododecupon              as string
     private  _78_tipointeres                 as string
     private  _79_tipovalor                   as string
     private  _80_tipoderevision              as string
     private  _81_codigoindice                as string


    Private _Columnas(81)                     As String 




Public Sub limpiarValores()
        _0_instrument                 = ""
        _1_tipo                       = ""
        _2_emision                    = ""
        _3_acronimo                   = ""
        _4_longname1                  = ""
        _5_tipodeinstrumentodecalog   = ""
        _6_tv                         = ""
        _7_rendimiento                = ""
        _8_emisora                    = ""
        _9_tipoinstrumento            = ""
        _10_fijofrevisablerdescuentod = ""
        _11_cuponesporvencer          = ""
        _12_cuponevencidos            = ""
        _13_periododecupo_1           = ""
        _14_periododecupon_2          = ""
        _15_sobretasademercado        = ""
        _16_sobretasatotal            = ""
        _17_tasacupon_1               = ""
        _18_tasacupon_2               = ""
        _19_fechadecolocacion         = ""
        _20_fechadevencimiento        = ""
        _21_diasporvencer             = ""
        _22_preciosuciomd_1           = ""
        _23_preciosuciomd_2           = ""
        _24_preciolimpiomd            = ""
        _25_sucio24hrs                = ""
        _26_duracionajustada          = ""
        _27_convexidad                = ""
        _28_valornominalactualizado   = ""
        _29_redemptionprice           = ""
        _30_valoresinscritos          = ""
        _31_montoencirculacion        = ""
        _32_isin_1                    = ""
        _33_isin_2                    = ""
        _34_isin_3                    = ""
        _35_curvadedescuento          = ""
        _36_codigoindice              = ""
        _37_tipointeres               = ""
        _38_iniciodecupon             = ""
        _39_findecupon                = ""
        _40_fitch                     = ""
        _41_syp                       = ""
        _42_moodys                    = ""
        _43_sobretasaendecalog        = ""
        _44_sobretasadecolocacion     = ""
        _45_isr                       = ""
        _46_guartyp                   = ""
        _47_serie                     = ""
        _48_tipoderevision            = ""
        _49_tipoderevisioncs          = ""
        _50_numofdaystype             = ""
        _51_category                  = ""
        _52_numdays                   = ""
        _53_diasporvencer             = ""
        _54_fechaemision              = ""
        _55_fechavencimiento          = ""
        _56_finicicupon               = ""
        _57_ffinalcupon               = ""
        _58_preciosuciomd             = ""
        _59_preciolimpiomd            = ""
        _60_valornominal              = ""
        _61_titulosdelemision         = ""
        _62_montodelaemision          = ""
        _63_tasacupon                 = ""
        _64_strike1                   = ""
        _65_strike2                   = ""
        _66_tasamaxima_tim            = ""
        _67_tasaminimagarantizada_tmg = ""
        _68_subyacente                = ""
        _69_estructura                = ""
        _70_concatenacion_nombre      = ""
        _71_notaendecalog             = ""
        _72_diasporvenceremision      = ""
        _73_diasporvenceremision      = ""
        _74_periodocupon              = ""
        _75_cuponesporvencer          = ""
        _76_cuponesvencidos           = ""
        _77_periododecupon            = ""
        _78_tipointeres               = ""
        _79_tipovalor                 = ""
        _80_tipoderevision            = ""
        _81_codigoindice              = ""

End Sub



Default ReadOnly  Property  Columnas(ByVal index As Integer) As String 
    Get
       Return _Columnas(index)
    End Get
    
End Property




Public Property P_0_instrument() As String
    Get
        Return _0_instrument
    End Get
    Set(ByVal value As String)
        _0_instrument = value
        _Columnas(0) = value
    End Set
End Property

Public Property P_1_tipo() As String
    Get
        Return _1_tipo
    End Get
    Set(ByVal value As String)
        _1_tipo = value
        _Columnas(1) = value
    End Set
End Property

Public Property P_2_emision() As String
    Get
        Return _2_emision
    End Get
    Set(ByVal value As String)
        _2_emision = value
        _Columnas(2) = value
    End Set
End Property


Public Property P_3_acronimo () As String
    Get
        Return _3_acronimo 
    End Get
    Set(ByVal value As String)
        _3_acronimo  = value
        _Columnas(3) = value
    End Set
End Property

Public Property P_4_longname1 () As String
    Get
        Return _4_longname1 
    End Get
    Set(ByVal value As String)
        _4_longname1  = value
        _Columnas(4) = value
    End Set
End Property

Public Property P_5_tipodeinstrumentodecalog() As String
    Get
        Return _5_tipodeinstrumentodecalog
    End Get
    Set(ByVal value As String)
        _5_tipodeinstrumentodecalog = value
        _Columnas(5) = value
    End Set
End Property


Public Property P_6_tv() As String
    Get
        Return _6_tv
    End Get
    Set(ByVal value As String)
        _6_tv = value
        _Columnas(6) = value
    End Set
End Property

Public Property P_7_rendimiento() As String
    Get
        Return _7_rendimiento
    End Get
    Set(ByVal value As String)
        _7_rendimiento = value
        _Columnas(7) = value
    End Set
End Property

Public Property P_8_emisora() As String
    Get
        Return _8_emisora
    End Get
    Set(ByVal value As String)
        _8_emisora = value
        _Columnas(8) = value
    End Set
End Property


Public Property P_9_tipoinstrumento() As String
    Get
        Return _9_tipoinstrumento
    End Get
    Set(ByVal value As String)
        _9_tipoinstrumento = value
        _Columnas(9) = value
    End Set
End Property

Public Property P_10_fijofrevisablerdescuentod() As String
    Get
        Return _10_fijofrevisablerdescuentod
    End Get
    Set(ByVal value As String)
        _10_fijofrevisablerdescuentod = value
        _Columnas(10) = value
    End Set
End Property


    


Public Property P_11_cuponesporvencer() As String
    Get
        Return _11_cuponesporvencer  
    End Get
    Set(ByVal value As String)
        _11_cuponesporvencer   = value
        _Columnas(11) = value
    End Set
End Property



Public Property P_12_cuponevencidos() As String
    Get
        Return _12_cuponevencidos 
    End Get
    Set(ByVal value As String)
        _12_cuponevencidos = value
        _Columnas(12) = value
    End Set
End Property


Public Property P_13_periododecupo_1 () As String
    Get
        Return _13_periododecupo_1 
    End Get
    Set(ByVal value As String)
        _13_periododecupo_1  = value
        _Columnas(13) = value 
    End Set
End Property

Public Property P_14_periododecupon_2() As String
    Get
        Return _14_periododecupon_2
    End Get
    Set(ByVal value As String)
        _14_periododecupon_2 = value
        _Columnas(14) = value
    End Set
End Property


Public Property P_15_sobretasademercado() As String
    Get
        Return _15_sobretasademercado
    End Get
    Set(ByVal value As String)
        _15_sobretasademercado = value
        _Columnas(15) = value
    End Set
End Property

Public Property P_16_sobretasatotal() As String
    Get
        Return _16_sobretasatotal
    End Get
    Set(ByVal value As String)
        _16_sobretasatotal = value
        _Columnas(16) = value
    End Set
End Property



Public Property P_17_tasacupon_1() As String
    Get
        Return _17_tasacupon_1
    End Get
    Set(ByVal value As String)
        _17_tasacupon_1 = value
        _Columnas(17) = value
    End Set
End Property


Public Property P_18_tasacupon_2() As String
    Get
        Return _18_tasacupon_2
    End Get
    Set(ByVal value As String)
        _18_tasacupon_2 = value
        _Columnas(18) = value 
    End Set
End Property

Public Property P_19_fechadecolocacion() As String
    Get
        Return _19_fechadecolocacion
    End Get
    Set(ByVal value As String)
        _19_fechadecolocacion = value
        _Columnas(19) = value
    End Set
End Property

Public Property P_20_fechadevencimiento() As String
    Get
        Return _20_fechadevencimiento
    End Get
    Set(ByVal value As String)
        _20_fechadevencimiento = value
        _Columnas(20) = value
    End Set
End Property



Public Property P_21_diasporvencer() As String
    Get
        Return _21_diasporvencer
    End Get
    Set(ByVal value As String)
        _21_diasporvencer = value
        _Columnas(21) = value
    End Set
End Property


Public Property P_22_preciosuciomd_1() As String
    Get
        Return _22_preciosuciomd_1 
    End Get
    Set(ByVal value As String)
        _22_preciosuciomd_1 = value
        _Columnas(22) = value
    End Set
End Property




Public Property P_23_preciosuciomd_2() As String
    Get
        Return _23_preciosuciomd_2 
    End Get
    Set(ByVal value As String)
        _23_preciosuciomd_2 = value
        _Columnas(23) = value
    End Set
End Property

    

Public Property P_24_preciolimpiomd() As String
    Get
        Return _24_preciolimpiomd
    End Get
    Set(ByVal value As String)
        _24_preciolimpiomd = value
        _Columnas(24) = value
    End Set
End Property




Public Property P_25_sucio24hrs() As String
    Get
        Return _25_sucio24hrs
    End Get
    Set(ByVal value As String)
        _25_sucio24hrs = value
        _Columnas(25) = value
    End Set
End Property

Public Property P_26_duracionajustada() As String
    Get
        Return _26_duracionajustada
    End Get
    Set(ByVal value As String)
        _26_duracionajustada = value
        _Columnas(26) = value
    End Set
End Property


Public Property P_27_convexidad() As String
    Get
        Return _27_convexidad 
    End Get
    Set(ByVal value As String)
        _27_convexidad = value
        _Columnas(27) = value
    End Set
End Property

Public Property P_28_valornominalactualizado() As String
    Get
        Return _28_valornominalactualizado 
    End Get
    Set(ByVal value As String)
        _28_valornominalactualizado = value
        _Columnas(28) = value
    End Set
End Property



Public Property P_29_redemptionprice() As String
    Get
        Return _29_redemptionprice
    End Get
    Set(ByVal value As String)
        _29_redemptionprice = value
        _Columnas(29) = value
    End Set
End Property


Public Property P_30_valoresinscritos() As String
    Get
        Return _30_valoresinscritos
    End Get
    Set(ByVal value As String)
        _30_valoresinscritos = value
        _Columnas(30) = value
    End Set
End Property


      
       
     
    
Public Property P_31_montoencirculacion() As String
    Get
        Return _31_montoencirculacion
    End Get
    Set(ByVal value As String)
        _31_montoencirculacion = value
        _Columnas(31) = value
    End Set
End Property



Public Property P_32_isin_1() As String
    Get
        Return _32_isin_1
    End Get
    Set(ByVal value As String)
        _32_isin_1 = value
        _Columnas(32) = value
    End Set
End Property


Public Property P_33_isin_2() As String
    Get
        Return _33_isin_2
    End Get
    Set(ByVal value As String)
        _33_isin_2 = value
        _Columnas(33) = value
    End Set
End Property



Public Property P_34_isin_3() As String
    Get
        Return _34_isin_3 
    End Get
    Set(ByVal value As String)
        _34_isin_3 = value
        _Columnas(34) = value
    End Set
End Property

Public Property P_35_curvadedescuento() As String
    Get
        Return _35_curvadedescuento 
    End Get
    Set(ByVal value As String)
        _35_curvadedescuento = value
        _Columnas(35) = value
    End Set
End Property



Public Property P_36_codigoindice() As String
    Get
        Return _36_codigoindice
    End Get
    Set(ByVal value As String)
        _36_codigoindice = value
        _Columnas(36) = value
    End Set
End Property

Public Property P_37_tipointeres() As String
    Get
        Return _37_tipointeres 
    End Get
    Set(ByVal value As String)
        _37_tipointeres = value
        _Columnas(37) = value
    End Set
End Property

Public Property P_38_iniciodecupon() As String
    Get
        Return _38_iniciodecupon
    End Get
    Set(ByVal value As String)
        _38_iniciodecupon = value
        _Columnas(38) = value
    End Set
End Property


Public Property P_39_findecupon() As String
    Get
        Return _39_findecupon 
    End Get
    Set(ByVal value As String)
        _39_findecupon = value
        _Columnas(39) = value
    End Set
End Property

Public Property P_40_fitch() As String
    Get
        Return _40_fitch
    End Get
    Set(ByVal value As String)
        _40_fitch = value
        _Columnas(40) = value
    End Set
End Property
                  

Public Property P_41_syp() As String
    Get
        Return _41_syp 
    End Get
    Set(ByVal value As String)
        _41_syp = value
        _Columnas(41) = value
    End Set
End Property


Public Property P_42_moodys() As String
    Get
        Return _42_moodys 
    End Get
    Set(ByVal value As String)
        _42_moodys = value
        _Columnas(42) = value
    End Set
End Property

Public Property P_43_sobretasaendecalog() As String
    Get
        Return _43_sobretasaendecalog
    End Get
    Set(ByVal value As String)
        _43_sobretasaendecalog = value
        _Columnas(43) = value
    End Set
End Property

Public Property P_44_sobretasadecolocacion() As String
    Get
        Return _44_sobretasadecolocacion 
    End Get
    Set(ByVal value As String)
        _44_sobretasadecolocacion = value
        _Columnas(44) = value
    End Set
End Property




Public Property P_45_isr() As String
    Get
        Return _45_isr
    End Get
    Set(ByVal value As String)
        _45_isr = value
        _Columnas(45) = value
    End Set
End Property

Public Property P_46_guartyp() As String
    Get
        Return _46_guartyp
    End Get
    Set(ByVal value As String)
        _46_guartyp = value
        _Columnas(46) = value 
    End Set
End Property

Public Property P_47_serie() As String
    Get
        Return _47_serie
    End Get
    Set(ByVal value As String)
        _47_serie = value
        _Columnas(47) = value
    End Set
End Property


Public Property P_48_tipoderevision() As String
    Get
        Return _48_tipoderevision
    End Get
    Set(ByVal value As String)
        _48_tipoderevision = value
        _Columnas(48) = value
    End Set
End Property

Public Property P_49_tipoderevisioncs() As String
    Get
        Return _49_tipoderevisioncs
    End Get
    Set(ByVal value As String)
        _49_tipoderevisioncs = value
        _Columnas(49) = value
    End Set
End Property




Public Property P_50_numofdaystype() As String
    Get
        Return _50_numofdaystype
    End Get
    Set(ByVal value As String)
        _50_numofdaystype = value
       _Columnas(50) = value
    End Set
End Property



Public Property P_51_category() As String
    Get
        Return _51_category
    End Get
    Set(ByVal value As String)
        _51_category = value
        _Columnas(51) = value
    End Set
End Property

Public Property P_52_numdays() As String
    Get
        Return _52_numdays
    End Get
    Set(ByVal value As String)
        _52_numdays = value
       _Columnas(52) = value
    End Set
End Property

Public Property P_53_diasporvencer() As String
    Get
        Return _53_diasporvencer
    End Get
    Set(ByVal value As String)
        _53_diasporvencer = value
        _Columnas(53) = value
    End Set
End Property


Public Property P_54_fechaemision() As String
    Get
        Return _54_fechaemision
    End Get
    Set(ByVal value As String)
        _54_fechaemision = value
        _Columnas(54) = value
    End Set
End Property

Public Property P_55_fechavencimiento() As String
    Get
        Return _55_fechavencimiento
    End Get
    Set(ByVal value As String)
        _55_fechavencimiento = value
        _Columnas(55) = value
    End Set
End Property


Public Property P_56_finicicupon() As String
    Get
        Return _56_finicicupon
    End Get
    Set(ByVal value As String)
        _56_finicicupon = value
        _Columnas(56) = value
    End Set
End Property


    

Public Property P_57_ffinalcupon() As String
    Get
        Return _57_ffinalcupon 
    End Get
    Set(ByVal value As String)
        _57_ffinalcupon = value
        _Columnas(57) = value
    End Set
End Property

Public Property P_58_preciosuciomd() As String
    Get
        Return _58_preciosuciomd
    End Get
    Set(ByVal value As String)
        _58_preciosuciomd = value
        _Columnas(58) = value
    End Set
End Property


Public Property P_59_preciolimpiomd() As String
    Get
        Return _59_preciolimpiomd
    End Get
    Set(ByVal value As String)
        _59_preciolimpiomd = value
        _Columnas(59) = value
    End Set
End Property


Public Property P_60_valornominal() As String
    Get
        Return _60_valornominal
    End Get
    Set(ByVal value As String)
        _60_valornominal = value
        _Columnas(60) = value
    End Set
End Property

                                                                     

Public Property P_61_titulosdelemision() As String
    Get
        Return _61_titulosdelemision
    End Get
    Set(ByVal value As String)
        _61_titulosdelemision = value
        _Columnas(61) = value
    End Set
End Property

Public Property P_62_montodelaemision() As String
    Get
        Return _62_montodelaemision 
    End Get
    Set(ByVal value As String)
        _62_montodelaemision = value
        _Columnas(62) = value
    End Set
End Property


Public Property P_63_tasacupon() As String
    Get
        Return _63_tasacupon
    End Get
    Set(ByVal value As String)
        _63_tasacupon = value
        _Columnas(63) = value
    End Set
End Property

Public Property P_64_strike1() As String
    Get
        Return _64_strike1 
    End Get
    Set(ByVal value As String)
        _64_strike1 = value
        _Columnas(64) = value
    End Set
End Property

Public Property P_65_strike2() As String
    Get
        Return _65_strike2 
    End Get
    Set(ByVal value As String)
        _65_strike2 = value
        _Columnas(65) = value
    End Set
End Property


Public Property P_66_tasamaxima_tim() As String
    Get
        Return _66_tasamaxima_tim 
    End Get
    Set(ByVal value As String)
        _66_tasamaxima_tim = value
        _Columnas(66) = value
    End Set
End Property

Public Property P_67_tasaminimagarantizada_tmg() As String
    Get
        Return _67_tasaminimagarantizada_tmg 
    End Get
    Set(ByVal value As String)
        _67_tasaminimagarantizada_tmg = value
        _Columnas(67) = value
    End Set
End Property

Public Property P_68_subyacente() As String
    Get
        Return _68_subyacente 
    End Get
    Set(ByVal value As String)
        _68_subyacente = value
        _Columnas(68) = value
    End Set
End Property


Public Property P_69_estructura() As String
    Get
        Return _69_estructura 
    End Get
    Set(ByVal value As String)
        _69_estructura = value
        _Columnas(69) = value
    End Set
End Property

Public Property P_70_concatenacion_nombre() As String
    Get
        Return _70_concatenacion_nombre 
    End Get
    Set(ByVal value As String)
        _70_concatenacion_nombre = value
        _Columnas(70) = value
    End Set
End Property


Public Property P_71_notaendecalog() As String
    Get
        Return _71_notaendecalog 
    End Get
    Set(ByVal value As String)
        _71_notaendecalog = value
        _Columnas(71) = value
    End Set
End Property



Public Property P_72_diasporvenceremision() As String
    Get
        Return _72_diasporvenceremision 
    End Get
    Set(ByVal value As String)
        _72_diasporvenceremision = value
        _Columnas(72) = value
    End Set
End Property

Public Property P_73_diasporvenceremision() As String
    Get
        Return _73_diasporvenceremision 
    End Get
    Set(ByVal value As String)
        _73_diasporvenceremision = value
        _Columnas(73) = value
    End Set
End Property

Public Property P_74_periodocupon() As String
    Get
        Return _74_periodocupon 
    End Get
    Set(ByVal value As String)
        _74_periodocupon = value
        _Columnas(74) = value
    End Set
End Property


Public Property P_75_cuponesporvencer() As String
    Get
        Return _75_cuponesporvencer 
    End Get
    Set(ByVal value As String)
        _75_cuponesporvencer = value
        _Columnas(75) = value
    End Set
End Property

Public Property P_76_cuponesvencidos() As String
    Get
        Return _76_cuponesvencidos 
    End Get
    Set(ByVal value As String)
        _76_cuponesvencidos = value
        _Columnas(76) = value
    End Set
End Property

Public Property P_77_periododecupon() As String
    Get
        Return _77_periododecupon 
    End Get
    Set(ByVal value As String)
        _77_periododecupon = value
        _Columnas(77) = value
    End Set
End Property


Public Property P_78_tipointeres() As String
    Get
        Return _78_tipointeres 
    End Get
    Set(ByVal value As String)
        _78_tipointeres = value
        _Columnas(78) = value
    End Set
End Property

Public Property P_79_tipovalor() As String
    Get
        Return _79_tipovalor 
    End Get
    Set(ByVal value As String)
        _79_tipovalor = value
        _Columnas(79) = value
    End Set
End Property

Public Property P_80_tipoderevision() As String
    Get
        Return _80_tipoderevision 
    End Get
    Set(ByVal value As String)
        _80_tipoderevision = value
        _Columnas(80) = value
    End Set
End Property


Public Property P_81_codigoindice() As String
    Get
        Return _81_codigoindice 
    End Get
    Set(ByVal value As String)
        _81_codigoindice = value
        _Columnas(81) = value
    End Set
End Property





















End Class
